{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "b6bb1b18",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '北京市朝阳区阜通东大街6号',\n",
       "   'country': '中国',\n",
       "   'province': '北京市',\n",
       "   'citycode': '010',\n",
       "   'city': '北京市',\n",
       "   'district': '朝阳区',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '110105',\n",
       "   'street': '阜通东大街',\n",
       "   'number': '6号',\n",
       "   'location': '116.482086,39.990496',\n",
       "   'level': '门牌号'}]}"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import requests\n",
    "import gaode\n",
    "\n",
    "gaode.get_address_info(\"北京市朝阳区阜通东大街6号\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "22f82adb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '北京市朝阳区阜通东大街6号',\n",
       "   'country': '中国',\n",
       "   'province': '北京市',\n",
       "   'citycode': '010',\n",
       "   'city': '北京市',\n",
       "   'district': '朝阳区',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '110105',\n",
       "   'street': '阜通东大街',\n",
       "   'number': '6号',\n",
       "   'location': '116.482086,39.990496',\n",
       "   'level': '门牌号'}]}"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import requests\n",
    "address = \"北京市朝阳区阜通东大街6号\"\n",
    "amap_key = \"2b2bd6b8229eaedb2480ce5cb877cb6c\"\n",
    "url = f\"https://restapi.amap.com/v3/geocode/geo?key={amap_key}&address={address}\"\n",
    "payload = {}\n",
    "headers = {}\n",
    "response = requests.request(\"GET\", url, headers=headers, data=payload)\n",
    "\n",
    "response.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "ed2f5cb4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "\n",
    "payload = {\n",
    "    \"key\":\"2b2bd6b8229eaedb2480ce5cb877cb6c\",\n",
    "    \"address\":\"广东省广州市从化区广州南方学院\"\n",
    "}\n",
    "r = requests.get(url=geo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "484bc291",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "e07a2d95",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '广东省广州市从化区温泉镇中心大学南方学院',\n",
       "   'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'citycode': '020',\n",
       "   'city': '广州市',\n",
       "   'district': '从化区',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '440117',\n",
       "   'street': [],\n",
       "   'number': [],\n",
       "   'location': '113.678280,23.628439',\n",
       "   'level': '兴趣点'}]}"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "9d12f969",
   "metadata": {},
   "outputs": [],
   "source": [
    "广州南方学院_location = r.json()['geocodes'][0]['location']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "id": "eb214d9b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.678280,23.628439'"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "广州南方学院_location"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "0cd86aee",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/regeo?parameters\"\n",
    "\n",
    "payload = {\n",
    "    \"key\":\"2b2bd6b8229eaedb2480ce5cb877cb6c\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"extensions\":\"all\",\n",
    "    \"poitype\":\"true\"\n",
    "}\n",
    "r = requests.get(url=geo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "715e111a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "53adc5de",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'regeocode': {'formatted_address': '广东省广州市从化区温泉镇博学路广州南方学院',\n",
       "  'addressComponent': {'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'city': '广州市',\n",
       "   'citycode': '020',\n",
       "   'district': '从化区',\n",
       "   'adcode': '440117',\n",
       "   'township': '温泉镇',\n",
       "   'towncode': '440117100000',\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'streetNumber': {'street': '博学路',\n",
       "    'number': '24号',\n",
       "    'location': '113.677267,23.629149',\n",
       "    'direction': '西北',\n",
       "    'distance': '129.943'},\n",
       "   'businessAreas': [[]]},\n",
       "  'pois': [{'id': 'B00140MR9A',\n",
       "    'name': '广州南方学院',\n",
       "    'type': '科教文化服务;学校;高等院校',\n",
       "    'tel': '020-87828988;020-61787331',\n",
       "    'direction': '北',\n",
       "    'distance': '470.792',\n",
       "    'location': '113.679257,23.632577',\n",
       "    'address': '温泉大道882号',\n",
       "    'poiweight': '0.450402',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFG4TAF2',\n",
       "    'name': '广州南方公寓',\n",
       "    'type': '商务住宅;商务住宅相关;商务住宅相关',\n",
       "    'tel': '13622768437',\n",
       "    'direction': '东南',\n",
       "    'distance': '102.617',\n",
       "    'location': '113.678983,23.627778',\n",
       "    'address': '温泉镇乌土村松浪队5号(近博学路)',\n",
       "    'poiweight': '0.237309',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0H6FA18J5',\n",
       "    'name': '保利半山花园',\n",
       "    'type': '商务住宅;住宅区;住宅区',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '139.054',\n",
       "    'location': '113.679358,23.627672',\n",
       "    'address': '从莞深高速(广州南方学院南侧)',\n",
       "    'poiweight': '0.223065',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B00140TWHT',\n",
       "    'name': '教工住宅1号',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '222.658',\n",
       "    'location': '113.678490,23.630432',\n",
       "    'address': '笃行路2',\n",
       "    'poiweight': '0.157653',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFHRJDM9',\n",
       "    'name': '中南公寓',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': '13711245345',\n",
       "    'direction': '东南',\n",
       "    'distance': '231.223',\n",
       "    'location': '113.680340,23.627566',\n",
       "    'address': '中大南方学院南门1号',\n",
       "    'poiweight': '0.256152',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD588HJ',\n",
       "    'name': '广州南方学院教学楼4号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '242.901',\n",
       "    'location': '113.677460,23.630490',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFHZH0IK',\n",
       "    'name': '地下铁',\n",
       "    'type': '餐饮服务;冷饮店;冷饮店',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '74.1376',\n",
       "    'location': '113.677941,23.629029',\n",
       "    'address': '博学路广州南方学院综合楼内',\n",
       "    'poiweight': '0.17934',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU76L2',\n",
       "    'name': '广州南方学院2号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '280.003',\n",
       "    'location': '113.678211,23.630956',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKP838K',\n",
       "    'name': '教学楼3号(外国语学院)',\n",
       "    'type': '科教文化服务;学校;高等院校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '298.093',\n",
       "    'location': '113.677247,23.630947',\n",
       "    'address': '博学路25',\n",
       "    'poiweight': '0.191742',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKSF1FI',\n",
       "    'name': '香辣螺蛳粉',\n",
       "    'type': '餐饮服务;餐饮相关场所;餐饮相关',\n",
       "    'tel': '17820061022',\n",
       "    'direction': '西',\n",
       "    'distance': '209.206',\n",
       "    'location': '113.676231,23.628565',\n",
       "    'address': '广州南方学院西4123',\n",
       "    'poiweight': '0.209252',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU8NLD',\n",
       "    'name': '广州南方学院1号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '326.007',\n",
       "    'location': '113.678215,23.631370',\n",
       "    'address': '博学路附近',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFLF90I2',\n",
       "    'name': '煌上煌酱鸭(南方学院店)',\n",
       "    'type': '餐饮服务;快餐厅;快餐厅',\n",
       "    'tel': '13712317721',\n",
       "    'direction': '东北',\n",
       "    'distance': '256.772',\n",
       "    'location': '113.679965,23.630156',\n",
       "    'address': '笃行路20、22、24号广州南方学院商业中心1层1F015',\n",
       "    'poiweight': '0.209448',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58UTU',\n",
       "    'name': '广州南方学院2号教学楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '346.352',\n",
       "    'location': '113.677060,23.631346',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.191229',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0H25SMRKP',\n",
       "    'name': '广州南方学院大礼堂',\n",
       "    'type': '科教文化服务;会展中心;会展中心',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '386.65',\n",
       "    'location': '113.680076,23.631502',\n",
       "    'address': '温泉大道882号',\n",
       "    'poiweight': '0.261624',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU92JD',\n",
       "    'name': '广州南方学院教学楼1号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '391.548',\n",
       "    'location': '113.677077,23.631783',\n",
       "    'address': '博学路19号',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD592BJ',\n",
       "    'name': '广州南方学院综合楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '392.731',\n",
       "    'location': '113.680117,23.631544',\n",
       "    'address': '温泉大道886号广州南方学院内',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKP81F0',\n",
       "    'name': '教学楼1号(文学与传媒学院)',\n",
       "    'type': '科教文化服务;科教文化场所;科教文化场所',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '393.93',\n",
       "    'location': '113.676866,23.631736',\n",
       "    'address': '博学路19号附近',\n",
       "    'poiweight': '0.191742',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFLBEOND',\n",
       "    'name': '聚贤楼10号',\n",
       "    'type': '商务住宅;住宅区;宿舍',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '418.51',\n",
       "    'location': '113.681253,23.631036',\n",
       "    'address': '从莞深高速(广州南方学院)',\n",
       "    'poiweight': '0.190963',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFH6K3U9',\n",
       "    'name': '广州中大南方招待所',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': '020-61787222',\n",
       "    'direction': '西北',\n",
       "    'distance': '378.102',\n",
       "    'location': '113.676330,23.631332',\n",
       "    'address': '温泉镇温泉大道882号广州南方学院H7栋1-5层',\n",
       "    'poiweight': '0.254885',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58NF8',\n",
       "    'name': '广州南方学院达人书院',\n",
       "    'type': '科教文化服务;科教文化场所;科教文化场所',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '446.366',\n",
       "    'location': '113.679041,23.632392',\n",
       "    'address': '温泉大道882号广州南方学院新综合楼2层',\n",
       "    'poiweight': '0.191229',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFKUVYWV',\n",
       "    'name': '广州和风庭阿七度假别墅',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '424.35',\n",
       "    'location': '113.681736,23.630569',\n",
       "    'address': '保利桃花源',\n",
       "    'poiweight': '0.273168',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU99RM',\n",
       "    'name': '广州南方学院图书馆',\n",
       "    'type': '科教文化服务;图书馆;图书馆',\n",
       "    'tel': '020-61787368;020-61787371',\n",
       "    'direction': '北',\n",
       "    'distance': '489.331',\n",
       "    'location': '113.679177,23.632762',\n",
       "    'address': '温泉大道882号广州南方学院内',\n",
       "    'poiweight': '0.257947',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU92JC',\n",
       "    'name': '广州南方学院4号实验楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '498.883',\n",
       "    'location': '113.679963,23.632652',\n",
       "    'address': '博学路附近',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFL7C054',\n",
       "    'name': '广州U优森特酒店',\n",
       "    'type': '住宿服务;住宿服务相关;住宿服务相关',\n",
       "    'tel': '15813395296',\n",
       "    'direction': '北',\n",
       "    'distance': '464.819',\n",
       "    'location': '113.679226,23.632528',\n",
       "    'address': '温泉镇博学路882号(广州南方学院商业中心1层)',\n",
       "    'poiweight': '0.317505',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0FFG8CSEK',\n",
       "    'name': 'L5员工宿舍',\n",
       "    'type': '商务住宅;住宅区;宿舍',\n",
       "    'tel': [],\n",
       "    'direction': '东北',\n",
       "    'distance': '554.129',\n",
       "    'location': '113.682583,23.631487',\n",
       "    'address': '从莞深高速(广州南方学院)',\n",
       "    'poiweight': '0.185371',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD58FR2',\n",
       "    'name': '广州南方学院教学楼9号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '532.163',\n",
       "    'location': '113.679747,23.633032',\n",
       "    'address': '广州南方学院',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HG5Z9JNK',\n",
       "    'name': '广州南方学院教学楼7号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '544.868',\n",
       "    'location': '113.678600,23.633330',\n",
       "    'address': '博学路',\n",
       "    'poiweight': '0.221553',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGD599JM',\n",
       "    'name': '广州南方学院第11教学楼',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '556.036',\n",
       "    'location': '113.680037,23.633173',\n",
       "    'address': '温泉大道882号广州南方学院',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0GUJYPEG2',\n",
       "    'name': '怒烤烤串(从化店)',\n",
       "    'type': '餐饮服务;中餐厅;特色/地方风味餐厅',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '510.112',\n",
       "    'location': '113.677160,23.632910',\n",
       "    'address': '温泉大道882号广州南方学院内博学路6号之3',\n",
       "    'poiweight': '0.216026',\n",
       "    'businessarea': []},\n",
       "   {'id': 'B0HGDU6Z41',\n",
       "    'name': '广州南方学院教学楼6号',\n",
       "    'type': '科教文化服务;学校;学校',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '586.331',\n",
       "    'location': '113.678424,23.633710',\n",
       "    'address': '温泉大道882',\n",
       "    'poiweight': '0.221662',\n",
       "    'businessarea': []}],\n",
       "  'roads': [{'id': '020F49F0050461206',\n",
       "    'name': '博学路',\n",
       "    'direction': '北',\n",
       "    'distance': '7.63232',\n",
       "    'location': '113.678,23.6284'},\n",
       "   {'id': '020F49F0050462229',\n",
       "    'name': '老虎形街',\n",
       "    'direction': '北',\n",
       "    'distance': '445.159',\n",
       "    'location': '113.679,23.6245'},\n",
       "   {'id': '020F49F0050462451',\n",
       "    'name': '中山路',\n",
       "    'direction': '南',\n",
       "    'distance': '708.299',\n",
       "    'location': '113.677,23.6347'}],\n",
       "  'roadinters': [{'direction': '南',\n",
       "    'distance': '708.299',\n",
       "    'location': '113.676794,23.634661',\n",
       "    'first_id': '020F49F0050461206',\n",
       "    'first_name': '博学路',\n",
       "    'second_id': '020F49F0050462451',\n",
       "    'second_name': '中山路'}],\n",
       "  'aois': [{'id': 'B00140MR9A',\n",
       "    'name': '广州南方学院',\n",
       "    'adcode': '440117',\n",
       "    'location': '113.679257,23.632577',\n",
       "    'area': '528560.656426',\n",
       "    'distance': '0',\n",
       "    'type': '141201'}]}}"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "9f1fce61",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "\n",
    "geo_url = \"https://restapi.amap.com/v5/place/text?parameters\"\n",
    "\n",
    "payload = {\n",
    "    \"key\":\"2b2bd6b8229eaedb2480ce5cb877cb6c\",\n",
    "    \"keywords\":\"中餐厅\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"show_fields\":\"photos,children,business\"\n",
    "}\n",
    "r = requests.get(url=geo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "e312b7f0",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "98fac7f8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'name': '湖边纸包鱼',\n",
       "   'id': 'B0FFL7NUA2',\n",
       "   'location': '113.679861,23.630285',\n",
       "   'type': '餐饮服务;中餐厅;四川菜(川菜)',\n",
       "   'typecode': '050102',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '广州南方学院',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'tel': '13924024938',\n",
       "    'rectag': '川菜',\n",
       "    'keytag': '川菜',\n",
       "    'rating': '4.4',\n",
       "    'opentime_today': '09:00-23:00',\n",
       "    'opentime_week': '09:00-23:00'},\n",
       "   'photos': [{'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/20080ba9f6fcd2808d64ce149b517ca9'},\n",
       "    {'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/9f40694ca108a175d36847d03ecf4ec0'},\n",
       "    {'title': '',\n",
       "     'url': 'https://img.alicdn.com/imgextra/i2/3695320962/O1CN01JFnmLv1IydhNhdLT4_!!3695320962-0-kbcontentapng.jpg'}]},\n",
       "  {'name': '壹休盖饭',\n",
       "   'id': 'B0HRHG0RSP',\n",
       "   'location': '113.679611,23.630517',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇乌土村上围2队13号',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'rectag': '盖饭', 'keytag': '盖饭'}},\n",
       "  {'name': '东记乡村美食',\n",
       "   'id': 'B0G3APADKJ',\n",
       "   'location': '113.679283,23.632572',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇广州南方学院后门润泰超市1层05号商铺',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'rectag': '粤菜', 'keytag': '粤菜'}},\n",
       "  {'name': '天天酒家(温泉东路)',\n",
       "   'id': 'B00140LJS7',\n",
       "   'location': '113.657777,23.640442',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇牌坊东路45号',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'business_area': '温泉',\n",
       "    'tel': '020-87838296;13533067893',\n",
       "    'rectag': '粤菜',\n",
       "    'keytag': '粤菜',\n",
       "    'rating': '4.4',\n",
       "    'cost': '56.00'},\n",
       "   'photos': [{'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/098f3972854783f4a0931f73645de6db'},\n",
       "    {'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/89a15022589f24ae17885d3374f31a84'}]},\n",
       "  {'name': '幸福楼酒店(温泉东路)',\n",
       "   'id': 'B00140FG8A',\n",
       "   'location': '113.654186,23.644836',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇温泉东路99号',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'business_area': '温泉',\n",
       "    'tel': '020-87838813;020-87838758',\n",
       "    'tag': '红葱头淋鸡,客家酿豆腐煲,山坑螺,清蒸叉尾鱼,炒山猪肉,清蒸肉丸,风味蒜香骨,砂锅豆腐,胡椒老鸡煲猪肚汤,客家蛋饺煲,豉汁蒸叉尾鱼,炆野山猪肉,芥菜咸骨煲,葱姜炒黄鳝,香煎黄花鱼',\n",
       "    'rectag': '粤菜',\n",
       "    'keytag': '粤菜',\n",
       "    'rating': '4.6',\n",
       "    'cost': '53.00',\n",
       "    'opentime_today': '10:00-21:00',\n",
       "    'opentime_week': '10:00-21:00'},\n",
       "   'photos': [{'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/18132bec7fd836ec909aae4ad8d92e5f'},\n",
       "    {'title': '产品图',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/9d00e60d9421930c973d23c0ce6fd0fb'},\n",
       "    {'title': '产品图',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/c12a7ff8105dd732137d63da821b6a5e'}]},\n",
       "  {'name': '潮汕砂锅粥',\n",
       "   'id': 'B0FFJ5J0XA',\n",
       "   'location': '113.655567,23.645315',\n",
       "   'type': '餐饮服务;中餐厅;广东菜(粤菜)',\n",
       "   'typecode': '050103',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇,碧泉一横街23号',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'business_area': '温泉',\n",
       "    'tel': '18588812880',\n",
       "    'rectag': '粤菜',\n",
       "    'keytag': '粤菜',\n",
       "    'rating': '4.1',\n",
       "    'cost': '37.00',\n",
       "    'opentime_today': '10:00-01:45',\n",
       "    'opentime_week': '10:00-01:45'},\n",
       "   'photos': [{'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/74d3adb93d9e3b8f5ffd05badd2d24eb'},\n",
       "    {'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/f160673b4058f79a1014e62f8c32166e'},\n",
       "    {'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/99f09d0032f41bcfb1da2f1cccc15d0c'}]},\n",
       "  {'name': '碧溪农家菜',\n",
       "   'id': 'B00140H71J',\n",
       "   'location': '113.654796,23.644038',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇碧泉路8号',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'business_area': '温泉',\n",
       "    'tel': '020-87838381;13527756813',\n",
       "    'rectag': '农家菜',\n",
       "    'keytag': '农家菜',\n",
       "    'rating': '4.2',\n",
       "    'cost': '74.00'},\n",
       "   'photos': [{'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/c6c4adb45d8da4215bb15b03f1b814a6'}]},\n",
       "  {'name': '温泉东埔农庄',\n",
       "   'id': 'B0FFF5KYEU',\n",
       "   'location': '113.662092,23.659556',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '东埔附近',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'tel': '13602211368;13902323168',\n",
       "    'rectag': '温泉洗浴',\n",
       "    'keytag': '温泉洗浴',\n",
       "    'rating': '4.4'}},\n",
       "  {'name': '乡约私房菜馆',\n",
       "   'id': 'B0FFLBF6O0',\n",
       "   'location': '113.654213,23.644589',\n",
       "   'type': '餐饮服务;中餐厅;广东菜(粤菜)',\n",
       "   'typecode': '050103',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '温泉镇温泉东路62号碧泉一横街二巷',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'business_area': '温泉',\n",
       "    'tel': '15918498423',\n",
       "    'rectag': '粤菜',\n",
       "    'keytag': '粤菜',\n",
       "    'rating': '4.1',\n",
       "    'opentime_today': '09:30-21:30',\n",
       "    'opentime_week': '09:30-21:30'},\n",
       "   'photos': [{'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/de46d11cc1c2d594328e981e47c30465'},\n",
       "    {'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/b3b9e19f80b52a27b9ef6717e2726d17'},\n",
       "    {'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/de240fa82a66bbc41319854ca9d8b9d9'}]},\n",
       "  {'name': '口味香农家菜',\n",
       "   'id': 'B0FFGDZKAP',\n",
       "   'location': '113.712702,23.620095',\n",
       "   'type': '餐饮服务;中餐厅;中餐厅',\n",
       "   'typecode': '050100',\n",
       "   'pname': '广东省',\n",
       "   'cityname': '广州市',\n",
       "   'adname': '从化区',\n",
       "   'address': '934县道温泉镇中田小学面对左边',\n",
       "   'pcode': '440000',\n",
       "   'citycode': '020',\n",
       "   'adcode': '440117',\n",
       "   'business': {'tel': '13711253571;18933901108',\n",
       "    'rectag': '农家菜',\n",
       "    'keytag': '农家菜',\n",
       "    'rating': '4.3',\n",
       "    'cost': '47.00'},\n",
       "   'photos': [{'title': '',\n",
       "     'url': 'http://store.is.autonavi.com/showpic/3c9e665e318d889a9d443d8c1ac2ce0c'}]}],\n",
       " 'count': '10'}"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "670191b8",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>id</th>\n",
       "      <th>location</th>\n",
       "      <th>type</th>\n",
       "      <th>typecode</th>\n",
       "      <th>pname</th>\n",
       "      <th>cityname</th>\n",
       "      <th>adname</th>\n",
       "      <th>address</th>\n",
       "      <th>pcode</th>\n",
       "      <th>...</th>\n",
       "      <th>photos</th>\n",
       "      <th>business.tel</th>\n",
       "      <th>business.rectag</th>\n",
       "      <th>business.keytag</th>\n",
       "      <th>business.rating</th>\n",
       "      <th>business.opentime_today</th>\n",
       "      <th>business.opentime_week</th>\n",
       "      <th>business.business_area</th>\n",
       "      <th>business.cost</th>\n",
       "      <th>business.tag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>湖边纸包鱼</td>\n",
       "      <td>B0FFL7NUA2</td>\n",
       "      <td>113.679861,23.630285</td>\n",
       "      <td>餐饮服务;中餐厅;四川菜(川菜)</td>\n",
       "      <td>050102</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州南方学院</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>[{'title': '', 'url': 'http://store.is.autonav...</td>\n",
       "      <td>13924024938</td>\n",
       "      <td>川菜</td>\n",
       "      <td>川菜</td>\n",
       "      <td>4.4</td>\n",
       "      <td>09:00-23:00</td>\n",
       "      <td>09:00-23:00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>壹休盖饭</td>\n",
       "      <td>B0HRHG0RSP</td>\n",
       "      <td>113.679611,23.630517</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>050100</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>温泉镇乌土村上围2队13号</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>盖饭</td>\n",
       "      <td>盖饭</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>东记乡村美食</td>\n",
       "      <td>B0G3APADKJ</td>\n",
       "      <td>113.679283,23.632572</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>050100</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>温泉镇广州南方学院后门润泰超市1层05号商铺</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>天天酒家(温泉东路)</td>\n",
       "      <td>B00140LJS7</td>\n",
       "      <td>113.657777,23.640442</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>050100</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>温泉镇牌坊东路45号</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>[{'title': '', 'url': 'http://store.is.autonav...</td>\n",
       "      <td>020-87838296;13533067893</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>4.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>温泉</td>\n",
       "      <td>56.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>幸福楼酒店(温泉东路)</td>\n",
       "      <td>B00140FG8A</td>\n",
       "      <td>113.654186,23.644836</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>050100</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>温泉镇温泉东路99号</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>[{'title': '', 'url': 'http://store.is.autonav...</td>\n",
       "      <td>020-87838813;020-87838758</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>4.6</td>\n",
       "      <td>10:00-21:00</td>\n",
       "      <td>10:00-21:00</td>\n",
       "      <td>温泉</td>\n",
       "      <td>53.00</td>\n",
       "      <td>红葱头淋鸡,客家酿豆腐煲,山坑螺,清蒸叉尾鱼,炒山猪肉,清蒸肉丸,风味蒜香骨,砂锅豆腐,胡椒...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>潮汕砂锅粥</td>\n",
       "      <td>B0FFJ5J0XA</td>\n",
       "      <td>113.655567,23.645315</td>\n",
       "      <td>餐饮服务;中餐厅;广东菜(粤菜)</td>\n",
       "      <td>050103</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>温泉镇,碧泉一横街23号</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>[{'title': '', 'url': 'http://store.is.autonav...</td>\n",
       "      <td>18588812880</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>4.1</td>\n",
       "      <td>10:00-01:45</td>\n",
       "      <td>10:00-01:45</td>\n",
       "      <td>温泉</td>\n",
       "      <td>37.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>碧溪农家菜</td>\n",
       "      <td>B00140H71J</td>\n",
       "      <td>113.654796,23.644038</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>050100</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>温泉镇碧泉路8号</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>[{'title': '', 'url': 'http://store.is.autonav...</td>\n",
       "      <td>020-87838381;13527756813</td>\n",
       "      <td>农家菜</td>\n",
       "      <td>农家菜</td>\n",
       "      <td>4.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>温泉</td>\n",
       "      <td>74.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>温泉东埔农庄</td>\n",
       "      <td>B0FFF5KYEU</td>\n",
       "      <td>113.662092,23.659556</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>050100</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>东埔附近</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13602211368;13902323168</td>\n",
       "      <td>温泉洗浴</td>\n",
       "      <td>温泉洗浴</td>\n",
       "      <td>4.4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>乡约私房菜馆</td>\n",
       "      <td>B0FFLBF6O0</td>\n",
       "      <td>113.654213,23.644589</td>\n",
       "      <td>餐饮服务;中餐厅;广东菜(粤菜)</td>\n",
       "      <td>050103</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>温泉镇温泉东路62号碧泉一横街二巷</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>[{'title': '', 'url': 'http://store.is.autonav...</td>\n",
       "      <td>15918498423</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>粤菜</td>\n",
       "      <td>4.1</td>\n",
       "      <td>09:30-21:30</td>\n",
       "      <td>09:30-21:30</td>\n",
       "      <td>温泉</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>口味香农家菜</td>\n",
       "      <td>B0FFGDZKAP</td>\n",
       "      <td>113.712702,23.620095</td>\n",
       "      <td>餐饮服务;中餐厅;中餐厅</td>\n",
       "      <td>050100</td>\n",
       "      <td>广东省</td>\n",
       "      <td>广州市</td>\n",
       "      <td>从化区</td>\n",
       "      <td>934县道温泉镇中田小学面对左边</td>\n",
       "      <td>440000</td>\n",
       "      <td>...</td>\n",
       "      <td>[{'title': '', 'url': 'http://store.is.autonav...</td>\n",
       "      <td>13711253571;18933901108</td>\n",
       "      <td>农家菜</td>\n",
       "      <td>农家菜</td>\n",
       "      <td>4.3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>47.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          name          id              location              type typecode  \\\n",
       "0        湖边纸包鱼  B0FFL7NUA2  113.679861,23.630285  餐饮服务;中餐厅;四川菜(川菜)   050102   \n",
       "1         壹休盖饭  B0HRHG0RSP  113.679611,23.630517      餐饮服务;中餐厅;中餐厅   050100   \n",
       "2       东记乡村美食  B0G3APADKJ  113.679283,23.632572      餐饮服务;中餐厅;中餐厅   050100   \n",
       "3   天天酒家(温泉东路)  B00140LJS7  113.657777,23.640442      餐饮服务;中餐厅;中餐厅   050100   \n",
       "4  幸福楼酒店(温泉东路)  B00140FG8A  113.654186,23.644836      餐饮服务;中餐厅;中餐厅   050100   \n",
       "5        潮汕砂锅粥  B0FFJ5J0XA  113.655567,23.645315  餐饮服务;中餐厅;广东菜(粤菜)   050103   \n",
       "6        碧溪农家菜  B00140H71J  113.654796,23.644038      餐饮服务;中餐厅;中餐厅   050100   \n",
       "7       温泉东埔农庄  B0FFF5KYEU  113.662092,23.659556      餐饮服务;中餐厅;中餐厅   050100   \n",
       "8       乡约私房菜馆  B0FFLBF6O0  113.654213,23.644589  餐饮服务;中餐厅;广东菜(粤菜)   050103   \n",
       "9       口味香农家菜  B0FFGDZKAP  113.712702,23.620095      餐饮服务;中餐厅;中餐厅   050100   \n",
       "\n",
       "  pname cityname adname                 address   pcode  ...  \\\n",
       "0   广东省      广州市    从化区                  广州南方学院  440000  ...   \n",
       "1   广东省      广州市    从化区           温泉镇乌土村上围2队13号  440000  ...   \n",
       "2   广东省      广州市    从化区  温泉镇广州南方学院后门润泰超市1层05号商铺  440000  ...   \n",
       "3   广东省      广州市    从化区              温泉镇牌坊东路45号  440000  ...   \n",
       "4   广东省      广州市    从化区              温泉镇温泉东路99号  440000  ...   \n",
       "5   广东省      广州市    从化区            温泉镇,碧泉一横街23号  440000  ...   \n",
       "6   广东省      广州市    从化区                温泉镇碧泉路8号  440000  ...   \n",
       "7   广东省      广州市    从化区                    东埔附近  440000  ...   \n",
       "8   广东省      广州市    从化区       温泉镇温泉东路62号碧泉一横街二巷  440000  ...   \n",
       "9   广东省      广州市    从化区        934县道温泉镇中田小学面对左边  440000  ...   \n",
       "\n",
       "                                              photos  \\\n",
       "0  [{'title': '', 'url': 'http://store.is.autonav...   \n",
       "1                                                NaN   \n",
       "2                                                NaN   \n",
       "3  [{'title': '', 'url': 'http://store.is.autonav...   \n",
       "4  [{'title': '', 'url': 'http://store.is.autonav...   \n",
       "5  [{'title': '', 'url': 'http://store.is.autonav...   \n",
       "6  [{'title': '', 'url': 'http://store.is.autonav...   \n",
       "7                                                NaN   \n",
       "8  [{'title': '', 'url': 'http://store.is.autonav...   \n",
       "9  [{'title': '', 'url': 'http://store.is.autonav...   \n",
       "\n",
       "                business.tel business.rectag business.keytag business.rating  \\\n",
       "0                13924024938              川菜              川菜             4.4   \n",
       "1                        NaN              盖饭              盖饭             NaN   \n",
       "2                        NaN              粤菜              粤菜             NaN   \n",
       "3   020-87838296;13533067893              粤菜              粤菜             4.4   \n",
       "4  020-87838813;020-87838758              粤菜              粤菜             4.6   \n",
       "5                18588812880              粤菜              粤菜             4.1   \n",
       "6   020-87838381;13527756813             农家菜             农家菜             4.2   \n",
       "7    13602211368;13902323168            温泉洗浴            温泉洗浴             4.4   \n",
       "8                15918498423              粤菜              粤菜             4.1   \n",
       "9    13711253571;18933901108             农家菜             农家菜             4.3   \n",
       "\n",
       "  business.opentime_today business.opentime_week business.business_area  \\\n",
       "0             09:00-23:00            09:00-23:00                    NaN   \n",
       "1                     NaN                    NaN                    NaN   \n",
       "2                     NaN                    NaN                    NaN   \n",
       "3                     NaN                    NaN                     温泉   \n",
       "4             10:00-21:00            10:00-21:00                     温泉   \n",
       "5             10:00-01:45            10:00-01:45                     温泉   \n",
       "6                     NaN                    NaN                     温泉   \n",
       "7                     NaN                    NaN                    NaN   \n",
       "8             09:30-21:30            09:30-21:30                     温泉   \n",
       "9                     NaN                    NaN                    NaN   \n",
       "\n",
       "  business.cost                                       business.tag  \n",
       "0           NaN                                                NaN  \n",
       "1           NaN                                                NaN  \n",
       "2           NaN                                                NaN  \n",
       "3         56.00                                                NaN  \n",
       "4         53.00  红葱头淋鸡,客家酿豆腐煲,山坑螺,清蒸叉尾鱼,炒山猪肉,清蒸肉丸,风味蒜香骨,砂锅豆腐,胡椒...  \n",
       "5         37.00                                                NaN  \n",
       "6         74.00                                                NaN  \n",
       "7           NaN                                                NaN  \n",
       "8           NaN                                                NaN  \n",
       "9         47.00                                                NaN  \n",
       "\n",
       "[10 rows x 22 columns]"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.json_normalize(r.json()['pois'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "8f4762f2",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "\n",
    "geo_url = \"https://restapi.amap.com/v5/place/text?parameters\"\n",
    "\n",
    "payload = {\n",
    "    \"key\":\"2b2bd6b8229eaedb2480ce5cb877cb6c\",\n",
    "    \"keywords\":\"西餐厅\",\n",
    "#     \"keywords\":\"中餐厅\",\n",
    "#     \"keywords\":\"快餐厅\",\n",
    "    \"location\":广州南方学院_location,\n",
    "    \"show_fields\":\"photos,children,business,navi\"\n",
    "}\n",
    "r = requests.get(url=geo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "7cc1fb6d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
